Release 10.1A: OpenEdge Data Management:
SQL Development

Stored procedure fundamentals

This section discusses the fundamentals of writing stored procedures.

The SQL CREATE PROCEDURE statement provides the basic framework for stored procedures. Use the CREATE PROCEDURE statement to submit a Java code snippet that will be compiled and stored in the database.

The CREATE PROCEDURE statement uses the following syntax:

Syntax

CREATE PROCEDURE [ owner_name.]procname    ( [ parameter_decl [ , ... ] ] )    [ RESULT ( column_name data_type [ , ... ] ) ]    [ IMPORT       java_import_clause ]    BEGIN       java_snippet    END

parameter_decl

Syntax

{ IN | OUT | INOUT } parameter_name data_type